In SAS Universal Viewer 1.3 or earlier versions, if you try to copy an entire SAS data set and then paste it into Excel, the column headings do not show up. Only the data are displayed. You can then manually type the column headings in Excel.

Or, you can install SAS^® Universal Viewer 1.4 or a later version.

SAS Universal Viewer 1.4 and later versions have new functionality and you can toggle this feature on or off. To accomplish that, take these steps:

1. Open SAS Universal Viewer 1.4 or higher and select Tools ► Options. On the Global tab, select Include headers when copying table selections.
2. Close SAS Universal Viewer.
3. Re-open SAS Universal Viewer and open a SAS data set.
   1. Click on the box in the upper left-hand corner of the table to highlight the entire table.
   2. Right-click on the highlighted table and choose Copy.
4. In Excel, right-click an empty cell and paste in the contents of the SAS data set. Verify that the column headings are included.

Note: If you deselect the option Include headers when copying table selections, then you need to restart SAS Universal Viewer for this new setting to take effect.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Universal Viewer	Microsoft® Windows® for x64	1.2	1.4		9.4 TS1M0
		Microsoft Windows Server 2008	1.2	1.4		9.4 TS1M1
		Microsoft Windows Server 2008 for x64	1.2	1.4		9.4 TS1M0
		Windows 7 Enterprise 32 bit	1.2	1.4		9.4 TS1M1
		Windows 7 Enterprise x64	1.2	1.4		9.4 TS1M0
		Windows 7 Home Premium 32 bit	1.2	1.4		9.4 TS1M1
		Windows 7 Home Premium x64	1.2	1.4		9.3 TS1M2
		Windows 7 Professional 32 bit	1.2	1.4		9.4 TS1M1
		Windows 7 Professional x64	1.2	1.4		9.4 TS1M0
		Windows 7 Ultimate 32 bit	1.2	1.4		9.4 TS1M1
		Windows 7 Ultimate x64	1.2	1.4		9.3 TS1M2
		Windows Vista	1.2	1.4		9.2 TS1M0
		Windows Vista for x64	1.2	1.4		9.2 TS1M0

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

This functionality was added to SAS® Universal Viewer 1.4 and later. The SAS Universal Viewer 1.3 and earlier versions do not copy column headings when you copy and paste the entire data set into Microsoft Excel.

Type:	Problem Note
Priority:	medium

Date Modified:	2021-03-01 09:01:12
Date Created:	2011-10-04 09:44:02